package com.roomno;
import java.util.Vector;
import java.sql.*;
import com.loginbean.DB;

public class RoomNo {

public Vector<Integer> vector = new Vector<Integer>();
	
	public Vector<Integer> getRoomNo (){
		 
		 try{
			 DB db= new DB();
			 ResultSet rs=db.executeQuery("select distinct roomNo from roomno order by roomNo");
			 while(rs.next())
			 {
				 vector.addElement( new Integer(rs.getString("roomNo")));
			 }
		 }catch(Exception e){
			 e.printStackTrace();
		 }
		
		 return vector;
	}

}
